USE admin GO CREATE TABLE EventID_Table (ID int primary key, Description varchar(50) ) GO INSERT INTO EventID_Table VALUES (0, 'Reserved') INSERT INTO EventID_Table VALUES (1, 'Reserved') INSERT INTO EventID_Table VALUES (2, 'Reserved') INSERT INTO EventID_Table VALUES (3, 'Reserved') INSERT INTO EventID_Table VALUES (4, 'Reserved') INSERT INTO EventID_Table VALUES (5, 'Reserved') INSERT INTO EventID_Table VALUES (6, 'Reserved') INSERT INTO EventID_Table VALUES (7, 'Reserved') INSERT INTO EventID_Table VALUES (8, 'Reserved') INSERT INTO EventID_Table VALUES (9, 'Reserved') INSERT INTO EventID_Table VALUES (10, 'RPC:Completed') INSERT INTO EventID_Table VALUES (11, 'RPC:Starting') INSERT INTO EventID_Table VALUES (12, 'SQL:BatchCompleted') INSERT INTO EventID_Table VALUES (13, 'SQL:BatchStarting') INSERT INTO EventID_Table VALUES (14, 'Login') INSERT INTO EventID_Table VALUES (15, 'Logout') INSERT INTO EventID_Table VALUES (16, 'Attention') INSERT INTO EventID_Table VALUES (17, 'ExistingConnection') INSERT INTO EventID_Table VALUES (18, 'ServiceControl') INSERT INTO EventID_Table VALUES (19, 'DTCTransaction') INSERT INTO EventID_Table VALUES (20, 'Login Failed') INSERT INTO EventID_Table VALUES (21, 'EventLog') INSERT INTO EventID_Table VALUES (22, 'ErrorLog') INSERT INTO EventID_Table VALUES (23, 'Lock:Released') INSERT INTO EventID_Table VALUES (24, 'Lock:Acquired') INSERT INTO EventID_Table VALUES (25, 'Lock:Deadlock') INSERT INTO EventID_Table VALUES (26, 'Lock:Cancel') INSERT INTO EventID_Table VALUES (27, 'Lock:Timeout') INSERT INTO EventID_Table VALUES (28, 'DOP Event') INSERT INTO EventID_Table VALUES (29, 'Reserved') INSERT INTO EventID_Table VALUES (30, 'Reserved') INSERT INTO EventID_Table VALUES (31, 'Reserved') INSERT INTO EventID_Table VALUES (32, 'Reserved') INSERT INTO EventID_Table VALUES (33, 'Exception') INSERT INTO EventID_Table VALUES (34, 'SP:CacheMiss') INSERT INTO EventID_Table VALUES (35, 'SP:CacheInsert') INSERT INTO EventID_Table VALUES (36, 'SP:CacheRemove') INSERT INTO EventID_Table VALUES (37, 'SP:Recompile') INSERT INTO EventID_Table VALUES (38, 'SP:CacheHit') INSERT INTO EventID_Table VALUES (39, 'SP:ExecContextHit') INSERT INTO EventID_Table VALUES (40, 'SQL:StmtStarting') INSERT INTO EventID_Table VALUES (41, 'SQL:StmtCompleted') INSERT INTO EventID_Table VALUES (42, 'SP:Starting') INSERT INTO EventID_Table VALUES (43, 'SP:Completed') INSERT INTO EventID_Table VALUES (44, 'Reserved ') INSERT INTO EventID_Table VALUES (45, 'Reserved ') INSERT INTO EventID_Table VALUES (46, 'Object:Created') INSERT INTO EventID_Table VALUES (47, 'Object:Deleted') INSERT INTO EventID_Table VALUES (48, 'Reserved') INSERT INTO EventID_Table VALUES (49, 'Reserved') INSERT INTO EventID_Table VALUES (50, 'SQL Transaction') INSERT INTO EventID_Table VALUES (51, 'Scan:Started') INSERT INTO EventID_Table VALUES (52, 'Scan:Stopped') INSERT INTO EventID_Table VALUES (53, 'CursorOpen') INSERT INTO EventID_Table VALUES (54, 'Transaction Log') INSERT INTO EventID_Table VALUES (55, 'Hash Warning') INSERT INTO EventID_Table VALUES (56, 'Reserved') INSERT INTO EventID_Table VALUES (57, 'Reserved') INSERT INTO EventID_Table VALUES (58, 'Auto Update Stats') INSERT INTO EventID_Table VALUES (59, 'Lock:Deadlock Chain') INSERT INTO EventID_Table VALUES (60, 'Lock:Escalation') INSERT INTO EventID_Table VALUES (61, 'OLE DB Errors') INSERT INTO EventID_Table VALUES (62, 'Reserved') INSERT INTO EventID_Table VALUES (63, 'Reserved') INSERT INTO EventID_Table VALUES (64, 'Reserved') INSERT INTO EventID_Table VALUES (65, 'Reserved') INSERT INTO EventID_Table VALUES (66, 'Reserved') INSERT INTO EventID_Table VALUES (67, 'Execution Warnings') INSERT INTO EventID_Table VALUES (68, 'Execution Plan') INSERT INTO EventID_Table VALUES (69, 'Sort Warnings') INSERT INTO EventID_Table VALUES (70, 'CursorPrepare') INSERT INTO EventID_Table VALUES (71, 'Prepare SQL') INSERT INTO EventID_Table VALUES (72, 'Exec Prepared SQL') INSERT INTO EventID_Table VALUES (73, 'Unprepare SQL') INSERT INTO EventID_Table VALUES (74, 'CursorExecute') INSERT INTO EventID_Table VALUES (75, 'CursorRecompile') INSERT INTO EventID_Table VALUES (76, 'CursorImplicitConversion') INSERT INTO EventID_Table VALUES (77, 'CursorUnprepare') INSERT INTO EventID_Table VALUES (78, 'CursorClose') INSERT INTO EventID_Table VALUES (79, 'Missing Column Statistics') INSERT INTO EventID_Table VALUES (80, 'Missing Join Predicate') INSERT INTO EventID_Table VALUES (81, 'Server Memory Change') INSERT INTO EventID_Table VALUES (82, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (83, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (84, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (85, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (86, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (87, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (88, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (89, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (90, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (91, 'User Configurable (0-9)') INSERT INTO EventID_Table VALUES (92, 'Data File Auto Grow') INSERT INTO EventID_Table VALUES (93, 'Log File Auto Grow') INSERT INTO EventID_Table VALUES (94, 'Data File Auto Shrink') INSERT INTO EventID_Table VALUES (95, 'Log File Auto Shrink') INSERT INTO EventID_Table VALUES (96, 'Show Plan Text') INSERT INTO EventID_Table VALUES (97, 'Show Plan ALL') INSERT INTO EventID_Table VALUES (98, 'Show Plan Statistics') INSERT INTO EventID_Table VALUES (99, 'Reserved') INSERT INTO EventID_Table VALUES (100, 'RPC Output Parameter') INSERT INTO EventID_Table VALUES (101, 'Reserved') INSERT INTO EventID_Table VALUES (102, 'Audit Statement GDR') INSERT INTO EventID_Table VALUES (103, 'Audit Object GDR') INSERT INTO EventID_Table VALUES (104, 'Audit Add/Drop Login') INSERT INTO EventID_Table VALUES (105, 'Audit Login GDR') INSERT INTO EventID_Table VALUES (106, 'Audit Login Change Property') INSERT INTO EventID_Table VALUES (107, 'Audit Login Change Password') INSERT INTO EventID_Table VALUES (108, 'Audit Add Login to Server Role') INSERT INTO EventID_Table VALUES (109, 'Audit Add DB User') INSERT INTO EventID_Table VALUES (110, 'Audit Add Member to DB') INSERT INTO EventID_Table VALUES (111, 'Audit Add/Drop Role') INSERT INTO EventID_Table VALUES (112, 'App Role Pass Change') INSERT INTO EventID_Table VALUES (113, 'Audit Statement Permission') INSERT INTO EventID_Table VALUES (114, 'Audit Object Permission') INSERT INTO EventID_Table VALUES (115, 'Audit Backup/Restore') INSERT INTO EventID_Table VALUES (116, 'Audit DBCC') INSERT INTO EventID_Table VALUES (117, 'Audit Change Audit') INSERT INTO EventID_Table VALUES (118, 'Audit Object Derived Permission')